UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5SiSfuSeaQ01gyH5zAWkOOluvTazx9b3vod4whT5I40='
WHERE
key_id = 'bb14ef596b213aa081012bfd30a7c6d6fe76f30e4e1d8415f671f817c99195a0'
AND (
token = '5SiSfuSeaQ01gyH5zAWkOOluvTazx9b3vod4whT5I40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)