UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nAPGAxt/vmKpcpQ5wDaeoi03C6fuTgqavSee3nRI18='
WHERE
key_id = 'fc4a868afb36c4378b3309658e41ff524ae466605ad8cf01217b829085b4d3e7'
AND (
token = '8nAPGAxt/vmKpcpQ5wDaeoi03C6fuTgqavSee3nRI18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)