UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCIu11xB3Mll3HK5u+8LAaGrVyp7qJOHob3dKV7j/Lo='
WHERE
key_id = 'fc5314623d01b2cf82a9ba19519a85ba7dcc9a217883903739b0a079f520aa27'
AND (
token = 'bCIu11xB3Mll3HK5u+8LAaGrVyp7qJOHob3dKV7j/Lo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)