UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zy1GI11/6fDS0iRCrVXkuhQJWeaO/B6tElkmY/KU2I8='
WHERE
key_id = '8d6e6cfb55c797bfb5319cc2db212f132453fe6e5704eadc4847cecd5ba6a43c'
AND (
token = 'zy1GI11/6fDS0iRCrVXkuhQJWeaO/B6tElkmY/KU2I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)