UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hnvhGw6103Xp6ysUS5IJC875tp0Cy+Jh/IylqjuazvI='
WHERE
key_id = '8c44f56423f53bbf3db85073c21b2f30001ba99245bc81c92916515ebdb39bed'
AND (
token = 'hnvhGw6103Xp6ysUS5IJC875tp0Cy+Jh/IylqjuazvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)