UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cVOrRdGbVXHwlvI7d0RpcVJXF2MZodR64D7K57HNCtw='
WHERE
key_id = 'd3c188e89d022d7d5ac3e49e0a3a784db273bd909cda2d5ec5b6cea7f12e36c0'
AND (
token = 'cVOrRdGbVXHwlvI7d0RpcVJXF2MZodR64D7K57HNCtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)