UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YB4RsY6K+fp0qCPXCHkTjwBJAv6s6UPPUErrJ9oBlio='
WHERE
key_id = '8ac0bbcd2bdc8b7e8d83014eee45be56f3f8473465782a099c43a2467e17ae0b'
AND (
token = 'YB4RsY6K+fp0qCPXCHkTjwBJAv6s6UPPUErrJ9oBlio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)