UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sx4MDJ7rScC0oCM+12BFlexDiVq0NnrNdRw9274KSfg='
WHERE
key_id = 'a3fb1eb2852117254490f1ac2c7f6aac10115aa18a5b19ddf5a359e1d9529d88'
AND (
token = 'sx4MDJ7rScC0oCM+12BFlexDiVq0NnrNdRw9274KSfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)