UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qbwaafnJ7WYI91BNBwJh1QClbaaQmS1/sBC9/gt4Ovc='
WHERE
key_id = 'ca4ad8ee0f35f2e502299d246281423fb22909fdf7808c78427999002a904987'
AND (
token = 'qbwaafnJ7WYI91BNBwJh1QClbaaQmS1/sBC9/gt4Ovc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)