UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'evWoCxA/CCF8lTfZaGmTXFlmOZSB3cdH7d6WIapR11M='
WHERE
key_id = 'a0c24c2d7cb904b4be981d628228d1ad7c459c5d86414f7b1ccab23a0ad9c060'
AND (
token = 'evWoCxA/CCF8lTfZaGmTXFlmOZSB3cdH7d6WIapR11M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)