UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bHPOJz82a1JCmBwoQNrrGTtjKQ498++duH1lDzqexOA='
WHERE
key_id = '3177c44097e68bcd202d70ccde8b8553f8ef3b84ae71b01eca5a4615ec0f67ba'
AND (
token = 'bHPOJz82a1JCmBwoQNrrGTtjKQ498++duH1lDzqexOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)