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