UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VN1xlGJT8UgSE2/rhLzsH4VMlPXXkdIg6hWcvKUSrPU='
WHERE
key_id = '8f0ad66eb35c1f89549381b8e90db7f8803d3a71da1d66e61765650f72ed965e'
AND (
token = 'VN1xlGJT8UgSE2/rhLzsH4VMlPXXkdIg6hWcvKUSrPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)