UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ShBl5hv9Kd1Bpw+zz3AaUUnhAtHyqchrbd0b7McRfIM='
WHERE
key_id = '6020d21599a072e9dbc3fa27339cedc49c564f4252c82c1bf953ed05f0cee198'
AND (
token = 'ShBl5hv9Kd1Bpw+zz3AaUUnhAtHyqchrbd0b7McRfIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)