UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tfSS1+yc58KddvBfvKY9LxXFR0a8vlnWC5764EqqhBA='
WHERE
key_id = 'f5e842d49fa87847cd6a3a64bffb017028be699feedf73d9d545a161b33b2253'
AND (
token = 'tfSS1+yc58KddvBfvKY9LxXFR0a8vlnWC5764EqqhBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)