UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jCfXaG4nJo7JPBpItkE5Igx+QCzEfSlao4ldXc7Wwlc='
WHERE
key_id = 'e07ef114485b58fa02e5dc2df40fef89a8fdf4d7ff72bfb03d9db78d9506e212'
AND (
token = 'jCfXaG4nJo7JPBpItkE5Igx+QCzEfSlao4ldXc7Wwlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)