UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rV5SgvnODoEBvx3+jjwaO6Dep1uSiVe4WbU9qQGgHO8='
WHERE
key_id = 'b54ff809b231cc686cea0e8e72effafdda48deb3f6186edda03d8e7e7d7cee69'
AND (
token = 'rV5SgvnODoEBvx3+jjwaO6Dep1uSiVe4WbU9qQGgHO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)