UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bqVqvfXzrCjWcl/V23DfXTU9Ljbq4Bq75lzzb5+gfgw='
WHERE
key_id = 'd58c7788228c312ce10896e7e5167a84baee536c054a3317c7589f7a7cd53cac'
AND (
token = 'bqVqvfXzrCjWcl/V23DfXTU9Ljbq4Bq75lzzb5+gfgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)