UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7EtlH0BwdIZD4cIPBTLXc1YfX892z1qH5anCpZEkDM='
WHERE
key_id = '03b755854fdc687672c3eaf086f359fd0a04dc97c7eb50766d8c55d26aca5ea1'
AND (
token = 'r7EtlH0BwdIZD4cIPBTLXc1YfX892z1qH5anCpZEkDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)