UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kTYEeOKkLD6OlttJmRzzW9VJtwscSx/ZMgF0ljxbGKE='
WHERE
key_id = '0d6962ecd8a2fa7eb85ad73c340e1ec29887c1e1212a819a2cd3129fcbcf341a'
AND (
token = 'kTYEeOKkLD6OlttJmRzzW9VJtwscSx/ZMgF0ljxbGKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)