UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EtFYw1t0gm/IFNBnfBYamShHEJLKz/droKBarqMFB0g='
WHERE
key_id = 'fec07399da2b88acadd56c0789c4af7a38497f082f5272e3b7263294ede9847b'
AND (
token = 'EtFYw1t0gm/IFNBnfBYamShHEJLKz/droKBarqMFB0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)