UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3/o9y4zk9ey9t0Ds81LOlvojcG/yc6zNPh2v2H5INZw='
WHERE
key_id = '237aa70e25f5b24a926638b3e45ca0d502c15462286bef681f19e8b77f252188'
AND (
token = '3/o9y4zk9ey9t0Ds81LOlvojcG/yc6zNPh2v2H5INZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)