UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcOOYQn252FUkZdl8nfLQKlQ76FVMpGyJtQua1au1s4='
WHERE
key_id = '67111479db4a19116de009b33689e7f4d1f28c1a63d0838d691374d01f246880'
AND (
token = 'bcOOYQn252FUkZdl8nfLQKlQ76FVMpGyJtQua1au1s4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)