UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHE5bcdxFkZwPqvJ5KxEmIppuZ4ywfsFE695PZDaNaw='
WHERE
key_id = 'b55c3ee493e05b209f0400c3ad6cc7272773fa3b84eed77e474f62c16e56ffc1'
AND (
token = 'NHE5bcdxFkZwPqvJ5KxEmIppuZ4ywfsFE695PZDaNaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)