UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCX9w7+hlIzYXS0MY5FqaQ2Tint2uvjpEMTcmFcNKHA='
WHERE
key_id = 'b391dd24947db22b5d522e437c7be856576dd8e139f7490529591a82bdf1cfee'
AND (
token = 'nCX9w7+hlIzYXS0MY5FqaQ2Tint2uvjpEMTcmFcNKHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)