UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mo7DJQBGUAxXwwBI5vltAvwfKM3fL7Ok0C6MHc0MOV4='
WHERE
key_id = '596c3d320350e71843964162a04386a2326897cba2560721169d2b28c04065e2'
AND (
token = 'mo7DJQBGUAxXwwBI5vltAvwfKM3fL7Ok0C6MHc0MOV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)