UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hPjNAjbDWRD5UmSoebN1COEYnQ4eGDeFWxx0+7iXM4U='
WHERE
key_id = 'd6b61bb840f21547a113a399e6bdb9663b77efb971bc8e5b12c29da22b6dfb29'
AND (
token = 'hPjNAjbDWRD5UmSoebN1COEYnQ4eGDeFWxx0+7iXM4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)