UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BKoC1mmNcvhKyQV4WOd5TPUn2c+xmuUN4xkAss4AYqA='
WHERE
key_id = 'cf3977f4cfe18fd5f1fe2ecf58bac3c3558c057f216d8af64ba69dd1dacea878'
AND (
token = 'BKoC1mmNcvhKyQV4WOd5TPUn2c+xmuUN4xkAss4AYqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)