UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4oTtj/cvw6dlJA3Oc4Vmb9a6eU4Mx5WOhl6KWijXLE='
WHERE
key_id = 'a0ad56297710c4aac49127ad4f99e0ad87beae920f9ff4b35eeb4916ff970f1d'
AND (
token = 'G4oTtj/cvw6dlJA3Oc4Vmb9a6eU4Mx5WOhl6KWijXLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)