UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nag4YGm5HI5EyBcoLnY2M6aKs8CIxvTiVDJY6vSZIKo='
WHERE
key_id = '7446fa7968df007993db3ec9b6afea25107a81054a013c696cd3f3370b6a59e4'
AND (
token = 'nag4YGm5HI5EyBcoLnY2M6aKs8CIxvTiVDJY6vSZIKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)