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