UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHA6pN7mtbZMtj5b5NPiHdVOEuvRpwtMw+p+o7mAyxw='
WHERE
key_id = 'fca084941e614757747478b7fc7888ce92e97305d7a321fba0526b8e4c979d70'
AND (
token = 'PHA6pN7mtbZMtj5b5NPiHdVOEuvRpwtMw+p+o7mAyxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)