UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5rNadPXc856rJO1U5bkHIGj578FzRLvoxYR6AKtkas='
WHERE
key_id = '0c802c5c2c3f46584e40d05bb9804b573306b56b1772cdd0af241e356e4f4150'
AND (
token = '/5rNadPXc856rJO1U5bkHIGj578FzRLvoxYR6AKtkas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)