UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k2J6OzGhm4SbFZWtghXwV2MUMemIca/XrAKz5kZtKRA='
WHERE
key_id = 'cc5a1865a0317301574b7e4083553ddbcb29d597a66bb8b9e71184d4ce95c5ea'
AND (
token = 'k2J6OzGhm4SbFZWtghXwV2MUMemIca/XrAKz5kZtKRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)