UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DgGrHYxpGQ+prU3VZh598Hk3FbFZMpT53Do7LGxsVxE='
WHERE
key_id = '01434b94cf9fb01780885f113c000f7026dfb76e5a4417bfbecac1936a3122d5'
AND (
token = 'DgGrHYxpGQ+prU3VZh598Hk3FbFZMpT53Do7LGxsVxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)