UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zUHCYuLLLizuKNJDZVIVRo2Qm1a61oaXqu5dRvJXUWE='
WHERE
key_id = '9d5e0146e0f33e67b05d7e3d15f7076c72c759cf33cee9bb41660cf9c6284990'
AND (
token = 'zUHCYuLLLizuKNJDZVIVRo2Qm1a61oaXqu5dRvJXUWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)