UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHNsHf1xhtYnd/6W3HbZd9c8RtGe2TapJF+u7V2xwaE='
WHERE
key_id = 'e313cc3abbc7fb672f5b8efb7de4d3d9cc50686f4b02f49a6ed8a42ee17ea1eb'
AND (
token = 'KHNsHf1xhtYnd/6W3HbZd9c8RtGe2TapJF+u7V2xwaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)