UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPb/xhWTmdIq9satzSd8JTNWK1RcCV7RO04djSE+3LY='
WHERE
key_id = '0331e57f89b7e069263e48640a0bd7d19ad82df0c093ee15d377625caabb8acc'
AND (
token = 'YPb/xhWTmdIq9satzSd8JTNWK1RcCV7RO04djSE+3LY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)